<-- style PDP --> 404 Mountain Brow Boulevard, Hamilton - Detached for sale for $2,750,000
  • leased
  • expired

404 Mountain Brow Boulevard

Hamilton, Ontario, L8T 1A7 - Sherwood

$2,750,000

  • Neighbourhood

    Sherwood

  • Major Intersection

    Mountain Brow Blvd and Fennell Avenue East

  • Listed Since: 185 day(s)

  • Last update: today

Overview

  • Property Type

    Detached, 2-Storey

  • Bedrooms

    5 + 1

  • Bathrooms

    6

  • Basement

    Finished

  • Kitchen

    1 + 1

  • Total Parking

    8 (2 Attached Garage)

  • Lot Size

    82.17x185.47 (Feet)

  • Taxes

    $18,422.00 (2026)

  • Type

    Freehold

Property Description

Property description for 404 Mountain Brow Boulevard, Hamilton

Custom-built luxury residence on prestigious Mountain Brow Blvd with breathtaking views of the Niagara Escarpment and Lake Ontario. Originally built in 1957, the home was extensively rebuilt in 2012. Nearly every component - including framing, mechanical systems, roofing, and interior finishes - was replaced or upgraded, offering the comfort and efficiency of a modern build with the charm of an established neighbourhood. The craftsman-inspired façade, clad in Georgian Bay limestone and board-and-batten, makes a striking first impression. A paved limestone-framed circular driveway enhances the curb appeal, along with an EV charging station, path lighting, and mature perennial gardens with irrigation. Inside, a cathedral ceiling and floating staircase set the tone in the grand foyer. The gourmet kitchen features granite counters, high-end appliances, cherry wood cabinetry, and a spacious walk-in pantry. It flows into an expansive dining room with a built-in fireplace and escarpment views - ideal for intimate dinners or large gatherings. Off the dining room, a bright study with heated floors and an indoor/outdoor gas fireplace leads to a four-season sunroom with serene backyard views. The backyard oasis includes a heated saltwater pool, retractable awnings, a 14' x 20' covered outdoor kitchen with gas fireplace, and a private annex. A double-sized family room with radiant heat and gas fireplace sits just off the kitchen, perfect for entertaining. Upstairs offers four spacious bedrooms, three bathrooms, and a central laundry room. The primary suite is a true retreat with a five-piece ensuite, walk-in closet, gas fireplace, and balcony with panoramic views. The basement provides a shared access in-law suite. The 37' x 20' backyard annex provides additional privacy and includes a guest suite with fireplace, in-floor heating, forced air, 3-piece bath, and gym. Every inch of this residence reflects luxury, comfort,**INTERBOARD LISTING: CORNERSTONE ASSOCIATION OF REALTORS**

Listed by KELLER WILLIAMS COMPLETE REALTY

  • MLS #

    X13437012

  • Sq. Ft

    3500-5000

  • Sq. Ft. Source

    MLS

  • Lot Irregularities

    n/a

  • Year Built

    51-99

  • Pool

    Inground, Salt

  • Drive

    Circular

  • Garage

    Attached, 2 spaces

  • Total Parking

    8

  • Family Room

    Y

  • Den

    Y

  • Exterior

    Board & Batten

  • Fireplace

    Y

  • Roof

    Asphalt Rolled, Shingles

  • Foundation

    Concrete Block, Poured Concrete

  • Elevator

    N

  • Water View

    n/a

  • Laundry Level

    Upper

  • Heat

    Forced Air

  • A/C

    Central Air

  • Water

    Municipal

  • Water Supply

    n/a

  • Sewers

    Sewers

  • Central Vac

    Y

  • Foyer

    44.2 x 58.83 ft Main level

    Vaulted Ceiling, Window Flr to Ceil, Floating Stairs

  • Family

    5.3 x 4.82 ft Main level

    2 Way Fireplace, W/O To Sunroom, Vaulted Ceiling

  • Dining

    7.16 x 3.99 ft Main level

    Fireplace, Tile Floor, Formal Rm

  • Kitchen

    5.7 x 4.18 ft Main level

    Pantry, B/I Appliances, Granite Counter

  • Sunroom

    6.22 x 4.82 ft Main level

    W/O To Patio, O/Looks Backyard, Sliding Doors

  • Living

    10.94 x 6.4 ft Main level

    Heated Floor, Sunken Room, Fireplace

  • Br

    6.43 x 5.27 ft Upper level

    4 Pc Ensuite, Fireplace, W/O To Balcony

  • 2nd Br

    3.9 x 3.63 ft Upper level

  • 3rd Br

    5.06 x 3.69 ft Upper level

    Walk-in Bath

  • 4th Br

    4.18 x 3.69 ft Upper level

    Walk-in Bath

  • Bathroom

    4.08 x 3.11 ft Upper level

    5 Pc Ensuite

  • Bathroom

    2.1 x 2.19 ft Upper level

    3 Pc Ensuite

  • Bathroom

    2.5 x 3.08 ft Upper level

    3 Pc Ensuite

  • Laundry

    3.84 x 2.29 ft Upper level

  • MLS #

    X13437012

  • Sq. Ft

    3500-5000

  • Sq. Ft. Source

    MLS

  • Lot Irregularities

    n/a

  • Year Built

    51-99

  • Pool

    Inground, Salt

  • Drive

    Circular

  • Garage

    Attached, 2 spaces

  • Total Parking

    8

  • Family Room

    Y

  • Den

    Y

  • Exterior

    Board & Batten

  • Fireplace

    Y

  • Roof

    Asphalt Rolled, Shingles

  • Foundation

    Concrete Block, Poured Concrete

  • Elevator

    N

  • Water View

    n/a

  • Laundry Level

    Upper

  • Heat

    Forced Air

  • A/C

    Central Air

  • Water

    Municipal

  • Water Supply

    n/a

  • Sewers

    Sewers

  • Central Vac

    Y

  • Foyer

    44.2 x 58.83 ft Main level

    Vaulted Ceiling, Window Flr to Ceil, Floating Stairs

  • Family

    5.3 x 4.82 ft Main level

    2 Way Fireplace, W/O To Sunroom, Vaulted Ceiling

  • Dining

    7.16 x 3.99 ft Main level

    Fireplace, Tile Floor, Formal Rm

  • Kitchen

    5.7 x 4.18 ft Main level

    Pantry, B/I Appliances, Granite Counter

  • Sunroom

    6.22 x 4.82 ft Main level

    W/O To Patio, O/Looks Backyard, Sliding Doors

  • Living

    10.94 x 6.4 ft Main level

    Heated Floor, Sunken Room, Fireplace

  • Br

    6.43 x 5.27 ft Upper level

    4 Pc Ensuite, Fireplace, W/O To Balcony

  • 2nd Br

    3.9 x 3.63 ft Upper level

  • 3rd Br

    5.06 x 3.69 ft Upper level

    Walk-in Bath

  • 4th Br

    4.18 x 3.69 ft Upper level

    Walk-in Bath

  • Bathroom

    4.08 x 3.11 ft Upper level

    5 Pc Ensuite

  • Bathroom

    2.1 x 2.19 ft Upper level

    3 Pc Ensuite

  • Bathroom

    2.5 x 3.08 ft Upper level

    3 Pc Ensuite

  • Laundry

    3.84 x 2.29 ft Upper level

Thinking of Selling?

Find Out Your Home’s Value in Today’s Market!

No Email or Signup is required to view your home estimate.

estimate your home value

Contact Manoj Kukreja

Sales Representative,
Century 21 People’s Choice Realty Inc.,
Brokerage
(647) 576 - 2100

Manoj profile avatar

Property History

Property history for 404 Mountain Brow Boulevard, Hamilton

This property has been sold 1 time before. Create your free account to explore sold prices, detailed property history, and more insider data.

Sign In / Register

Mortgage Calculator

This data is for informational purposes only.

Mortgage Payment per month

Principal Amount

Interest

Total Payable

Amortization

Amortization

Closing Cost Calculator

This data is for informational purposes only.

Closing Cost Total for this property

Total Cash flow for purchasing this property

Down Payment(%)*
Additional information

Provincial Land Transfer Tax

Ontario Land Transfer Tax Rebate

Toronto Land Transfer Tax

Toronto Land Transfer Tax Rebate

PST on CMHC Insurance Premium

Lawyer Fees

$2,825

Government Registration Fee's

$164

Title Insurance

Closing Cost Total

Total Cash flow for purchasing this property

Provincial Land Transfer Tax

Ontario Land Transfer Tax Rebate

Toronto Land Transfer Tax

Toronto Land Transfer Tax Rebate

PST on CMHC Insurance Premium

Lawyer Fees

$2,825

Government Registarion Fee's

$164

Title Insurance

Down Payment(%)*

* A down payment of less than 20% is permitted only for first-time home buyers purchasing their principal residence. The minimum down payment required is 5% for the portion of the purchase price up to $500,000, and 10% for the portion between $500,000 and $1,500,000. For properties priced over $1,500,000, a minimum down payment of 20% is required.

Thinking of Selling?

Find Out Your Home’s Value in Today’s Market!

No Email or Signup is required to view your home estimate.

estimate your home value

Contact Manoj Kukreja

Sales Representative, Century 21 People’s Choice Realty Inc., Brokerage
(647) 576 - 2100

Manoj profile avatar

Recent Sold Listings in Sherwood, Hamilton

Popular Cities